package com.worthtech.billportal.dao;

import java.util.HashMap;
import java.util.List;

import com.worthtech.billportal.bean.BillInfoOracle;
import com.worthtech.billportal.bean.WtLyCard;
import com.worthtech.billportal.exception.SCException;

public interface BillOracleDAO {
	
	public BillInfoOracle saveBill(BillInfoOracle billInfoOracle)
	throws SCException;
	public void saveOrUpdate(WtLyCard w);
	public void delete(WtLyCard w);
	public List getListByHQL(String tableName, int startPage, int perNo,
			String orderby);
	public String getCount(String tableName, String condition);
	public String getSum(String list,String tableName, String condition);
	public List getListBySQL(String tableName, int startPage, int perNo,
			String orderby);
	public void update(WtLyCard w);
	public String getCountBySQL(String tableName, String condition) ;
	public String getSumBySQL(String list,String tableName, String condition);;
	public String getbySql(String sql);
	public void toSql(String sql) throws Exception;
	public HashMap getDatainfo(String tablename, String code, String start,
			String end,String ordey) ;
	public List getPayCount(String tablename, String khcode1, String hncode2, String hnpaycode3, String depaycode4, String xepaycode5, String start,
			String end,String ordey);
	public HashMap getOrg(String tablename,String sql);
	public List getByStr(String orgcode);
}
